You have been asked to submit a weekly timesheet to show how many hours you have spent working on different projects, and how much you should be paid.

1. Download the file Weekly_Hours_Student_Template, copy and paste the data into a spreadsheet application.
2. Modify the table such that Project E could be added below Project D - the record is Mon (2 hours), Tue (1 hour), Wed (2 hours), Thur (1 hour), and Fri (2 hours).
3. Complete the field Total. section
4. In the cell below Hourly rate, write the text Total Cost of Project A. Calculate the total amount paid on Project A for the week and enter the result in the horizontal adjacent cell.
5. In the cell below 'Total Cost of Project A', write the text Total Cost of Labour on Monday. Calculate the total amount paid on all 'Project A' for the week and enter the result in the horizontal adjacent cell.
6. In the cell below Total Cost of Labour on Monday, write the text Total Cost of Labour on Thursday for Project C. Calculate the total amount paid on Project C and enter the result in the horizontal adjacent cell.
7. Format the spreadsheet so that:
   • all text is viewable
   • all column and row headings are bold
   • the top row is shaded
8. What is the number of hours spent working on Project E.
9. What is the total hours spent working on all the projects.
10. Multiply the total hours by the hourly rate to calculate the weekly total.
11. Format the hourly rate and weekly total to £ and 2 decimal places.
12. Use a pie chart to represent both columns of project and Mon.
13. Use a suitable chart to represent both fields of the project and Mon. Add a suitable heading and labels to your chart for clarity. Copy and paste the graph in another page named graph .

Name your wookbook Timesheet and upload it below.